<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@page import="com.jdbc.Jdbc"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="com.project.bean.*"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<% 
//权限管理
/* String role=(String) request.getSession().getAttribute("role");
String username = (String)request.getSession().getAttribute("username");
String find =null;
System.out.println(role);
System.out.println(role.equals("管理员"));

if(role.equals("管理员")){
	find = "select* from sales";
}
else{
	find = "select* from sales where username='"+username+"'";
} */
//首先获取显示页面用户的权限

  ResultSet rs=(ResultSet)request.getAttribute("resultset");
  List<Sales> list=new ArrayList<>();

  while(rs.next()){
	  Sales sa=new Sales();
	  sa.setId(rs.getString("id"));
	  sa.setChinesename(rs.getString("chinesename"));
	  list.add(sa);
  }%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<meta charset="utf-8">
<title>签约显示</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
	content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="format-detection" content="telephone=no">
<link rel="stylesheet" href="./css/x-admin.css" media="all">
</head>
<body>
	<div class="x-nav">
		<span class="layui-breadcrumb"> <a><cite>首页</cite></a> <a><cite>用户管理</cite></a>
		</span> <a class="layui-btn layui-btn-small"
			style="line-height: 1.6em; margin-top: 3px; float: right"
			href="javascript:location.reload(location.href);" title="刷新"><i
			class="layui-icon" style="line-height: 30px">ဂ</i></a>
	</div>
	<div class="x-body">
		<form class="layui-form x-center" action="" style="width: 500px">
			<div class="layui-form-pane" style="margin-top: 15px;">
				<div class="layui-form-item">
					<div class="layui-input-inline" style="width: 400px"></div>
					<div class="layui-input-inline" style="width: 80px"></div>
				</div>
			</div>
		</form>
		<!-- <xblock>
            <button class="layui-btn" onclick="user_management_add('添加用户','sales_add.jsp','600','500')"><i class="layui-icon">&#xe608;</i>添加</button>
            <button class="layui-btn" onclick=""><form action="salesOutput" method="post"><input type="submit"  class="layui-btn"  value="销售表导出"></form></button>
            <button class="layui-btn" onclick="user_management_add('数据导入','salesInputDB.jsp','600','500')"><i class="layui-icon"></i>Excel导入数据库</button>
            <button class="layui-btn" onclick=""><form action="salesModel" method="post"><input type="submit"  class="layui-btn"  value="模板下载"></form></button>
            <span class="x-right" style="line-height:25px"></span></xblock> -->
            
		<table class="layui-table">
			<thead>
				<tr>

					<th>学生编号</th>
					<th>中文名</th>
					<th>添加预约</th>
					<th>预约详情</th>


				</tr>
			</thead>
			<tbody>
				<%
    for(Sales sales:list){
   %>
				<tr>

					<td><%=sales.getId() %></td>
					<td><%=sales.getChinesename() %></td>
					<td>
						<button class="layui-btn"
							onclick="user_management_add('预约添加','reservation_add.jsp?stuid=<%=sales.getId()%>&sname=<%=sales.getChinesename()%>','600','500')">
							<i class="layui-icon">&#xe608;</i>添加
						</button>
					</td>
					<td><u style="cursor: pointer"
						onclick="user_management_show('预约情况','person_reservation.jsp?stuid=<%=sales.getId()%>&sname=<%=sales.getChinesename()%>','900','600')">预约详情</u>
					</td>





					<%--  <td class="td-manage">
<!--                             <a title="编辑" href="javascript:;" onclick="user_management_edit('编辑','user_management_edit.html','4','','510')"
                            class="ml-5" style="text-decoration:none">
                                <i class="layui-icon">&#xe642;</i>
                            </a> -->
                            <!-- <a style="text-decoration:none"  onclick="user_management_password('修改密码','user_management_password.jsp','10001','600','400')"
                            href="javascript:;" title="修改密码">
                                <i class="layui-icon">&#xe631;</i>
                            </a> -->
                            <a title="删除" href="javascript:;" onclick="user_management_delete('删除用户','sales_delete.jsp?id=<%=sales.getId() %>','10001','600','400')"
                            style="text-decoration:none">
                                <i class="layui-icon">&#xe640;</i>
                            </a>
                        </td> --%>
				</tr>


			</tbody>
			<%} %>
		</table>
<a class="layui-btn layui-btn-small"
			style="line-height: 1.6em; margin-top: 3px; float: right"
			href="reservation_show.jsp" ><i>后退</i></a>
		<!-- <div id="page"></div> -->
	</div>
	<br />
	<br />
	<br />
	<script src="./lib/layui/layui.js" charset="utf-8"></script>
	<script src="./js/x-layui.js" charset="utf-8"></script>
	<script>
            layui.use(['laydate','element','laypage','layer'], function(){
                $ = layui.jquery;//jquery
              laydate = layui.laydate;//日期插件
              lement = layui.element();//面包导航
              laypage = layui.laypage;//分页
              layer = layui.layer;//弹出层

              //以上模块根据需要引入

              laypage({
                cont: 'page'
                ,pages: 100
                ,first: 1
                ,last: 100
                ,prev: '<em><</em>'
                ,next: '<em>></em>'
              }); 
              
              var start = {
                min: laydate.now()
                ,max: '2099-06-16 23:59:59'
                ,istoday: false
                ,choose: function(datas){
                  end.min = datas; //开始日选好后，重置结束日的最小日期
                  end.start = datas //将结束日的初始值设定为开始日
                }
              };
              
              var end = {
                min: laydate.now()
                ,max: '2099-06-16 23:59:59'
                ,istoday: false
                ,choose: function(datas){
                  start.max = datas; //结束日选好后，重置开始日的最大日期
                }
              };
              
            });

            //批量删除提交
             function delAll () {
                layer.confirm('确认要删除吗？',function(index){
                    //捉到所有被选中的，发异步进行删除
                    layer.msg('删除成功', {icon: 1});
                });
             }
             /*用户-添加*/
            function user_management_add(title,url,w,h){
                x_admin_show(title,url,w,h);
            }
            /*用户-查看*/
            function user_management_show(title,url,w,h){
                x_admin_show(title,url,w,h);
            }

             /*用户-停用*/
            function member_stop(obj,id){
                layer.confirm('确认要停用吗？',function(index){
                    //发异步把用户状态进行更改
                    $(obj).parents("tr").find(".td-manage").prepend('<a style="text-decoration:none" onClick="member_start(this,id)" href="javascript:;" title="启用"><i class="layui-icon">&#xe62f;</i></a>');
                    $(obj).parents("tr").find(".td-status").html('<span class="layui-btn layui-btn-disabled layui-btn-mini">已停用</span>');
                    $(obj).remove();
                    layer.msg('已停用!',{icon: 5,time:1000});
                });
            }

            /*用户-启用*/
            function member_start(obj,id){
                layer.confirm('确认要启用吗？',function(index){
                    //发异步把用户状态进行更改
                    $(obj).parents("tr").find(".td-manage").prepend('<a style="text-decoration:none" onClick="member_stop(this,id)" href="javascript:;" title="停用"><i class="layui-icon">&#xe601;</i></a>');
                    $(obj).parents("tr").find(".td-status").html('<span class="layui-btn layui-btn-normal layui-btn-mini">已启用</span>');
                    $(obj).remove();
                    layer.msg('已启用!',{icon: 6,time:1000});
                });
            }
            // 用户-编辑
            function user_management_edit (title,url,id,w,h) {
                x_admin_show(title,url,w,h); 
            }
            /*密码-修改*/
            function user_management_password(title,url,id,w,h){
                x_admin_show(title,url,w,h);  
            }
            //删除用户
            function user_management_delete(title,url,id,w,h){
                x_admin_show(title,url,w,h);  
            }
            /*用户-删除*/
            function member_del(obj,id){
                layer.confirm('确认要删除吗？',function(index){
                    //发异步删除数据
                    $(obj).parents("tr").remove();
                    layer.msg('已删除!',{icon:1,time:1000});
                });
            }
            </script>
	<script>
        var _hmt = _hmt || [];
        (function() {
          var hm = document.createElement("script");
          var s = document.getElementsByTagName("script")[0]; 
          s.parentNode.insertBefore(hm, s);
        })();
        </script>
</body>
</html>